<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateDeliverScheduleTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('deliver_schedule', function (Blueprint $table) {
            $table->increments('id');
            $table->unsignedInteger('deliver_id')->nullable()->index()->comment('简历投递表ID');
            $table->timestamp('plan_time')->comment('预计入职时间');
            $table->unsignedInteger('try_wage')->nullable()->comment('试用期薪资');
            $table->unsignedInteger('wage')->nullable()->comment('转正薪资');
            $table->text('content')->comment('沟通记录');
            $table->unsignedInteger('uid')->nullable()->comment('跟进人');
            $table->unsignedInteger('assign')->nullable()->comment('归属人');
            $table->unsignedInteger('result')->default(1)->comment('面试情况 1待推荐,2已推荐,3筛选通过,4安排一面,5一面fail,6安排二面,7二面fail,8面试通过,9offer中,10接offer,11拒offer,12待入职,13已入职');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('deliver_schedule');
    }
}
